# coding: utf-8
from common.models.user import User
from application import db


class ParterIndex(db.Model):
    __tablename__ = 'parter_index'

    id = db.Column(db.Integer, primary_key=True)
    name = db.Column(db.String(255, 'utf8mb4_0900_ai_ci'))
    type = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    address = db.Column(db.String(255, 'utf8mb4_0900_ai_ci'))
    owner = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    phone = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    updated_time = db.Column(db.DateTime)
    created_time = db.Column(db.DateTime)
    uid = db.Column(db.Integer)
    mark = db.Column(db.Integer)
    status = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    gctype = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    zytype = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    linker = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    offer = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    isdone = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    area = db.Column(db.String(30, 'utf8mb4_0900_ai_ci'))
    ysdate = db.Column(db.Date)
    kcdate = db.Column(db.Date)



